Mike -
Nov 24, 2010 at 12:42 PM - Latest reply: amazed
- Dec 30, 2015 at 08:17 PM

Related:

- Apply conditional formatting to entire column
- How to apply conditional formatting to entire column - Best answers
- Excel apply conditional formatting to entire column ✓ - Forum - Excel
- Conditional formatting of entire column ✓ - Forum - Office Software
- Copy conditional formatting for an entire row based on one cell ✓ - Forum - Excel
- How to apply conditional formatting to multiple rows - How-To - Excel
- Apply conditional formatting to multiple rows - Forum - Excel

Best answer

TrowaD

- Posts
- 2447
- Registration date
- Sunday September 12, 2010
- Status
- Contributor
- Last seen
- November 15, 2018

Hi Mike,

Select cell H1, goto top menu's > format > conditional format.

Condition 1:

formula is: G1=1 apply desired format.

Condition 2:

formula is: G1=2 apply desired format.

Condition 3:

formula is: G1=3 apply desired format.

Click OK.

Drag cell H1 down.

If you already have data in column H, select "format only" from the small square that appears when you are donw dragging.

Best regards,

Trowa

Select cell H1, goto top menu's > format > conditional format.

Condition 1:

formula is: G1=1 apply desired format.

Condition 2:

formula is: G1=2 apply desired format.

Condition 3:

formula is: G1=3 apply desired format.

Click OK.

Drag cell H1 down.

If you already have data in column H, select "format only" from the small square that appears when you are donw dragging.

Best regards,

Trowa

Dragging down the H1 cell with the formula is not helping me replicate the same in the dragged down cells. Please help

Alleluia! Working on a =if($G1>$H1,true,false) and it works great.

So, in conditional format, with G5 selected, I put G7<>"", then format red and bold

Any suggestions?