Conditional formatting

Hello Lisa,

Just checking to see if the conditional formatting is still not performing the way you want it to.

I don't have your data in front of me, however, I presume the sales data is entered into a single column. If this is so, then do the following:

1) Select the data range i.e. A2:G250 (don't include your headings) OR select the row numbers from 2 to 250 (if you want the ENTIRE row to be highlighted).

2) Click Conditional Formatting

3) Click New Rule

4) Select the Rule Type: Use a Formula to determine which cells to format

5) Enter the following formula: =$F2>1 (assuming that the sales data is entered into column F starting from row 2)

6) Format using whatever colours etc. you desire.

7) Click OK until you have exited the conditional formatting dialogue box.

8) Enter data into column F and the row will now be highlighted.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer