How To Apply Conditional Formatting in Excel [Solved/Closed]
Hello,
I need to apply conditional formatting to range H1:H10000 based on corresponding values in another column, G1:G10000.
If the value in the G cell = 1, then I want the H cell to be blue and bold.
If the value in the G cell = 2, then I want the H cell to be purple and bold.
If the value in the G cell = 3, then I want the H cell to be red and bold.
Otherwise, I want no formatting.
For example, if cell G65 = 3, then I want cell H65 to be red and bold.
Any help is much appreciated.
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?