# Conditional Formatting for Entire Row Based on Data in One Cell

Assuming that D is the column containing the status cells, and you wish to apply conditional formatting to rows 1:50, here are the steps:

1\. Select any cell in row 1

2\. Go to 'Conditional Formatting>New Rule>Use a formula to determine which cells to format'

3\. In the formula field paste `=$D1="Shipped"`, set the required format and click 'OK'

4\. Go to 'Conditional Formatting>Manage Rules' and locate the rule you have just created

5\. In the field 'Applies to' paste '`=$1:$50`', or just select the required rows, starting from row 1, then click 'OK'.

If you type the word 'SHIPPED' in any cell of the column D (rows 1 to 50), the entire row will be conditionally formatted

For representing negative numbers, use the following formula.

```
=$D2<0
```

For representing positive numbers, use the following formula.

```
=$D2>0
```