For you Excel Gurus

Juice Box

Diamond Member
Nov 7, 2003
9,615
1
0
So lets say I have a Row.....

what I want to do is have it so when A1 = "No" The whole Row 1 Becomes Filled Red... I know you have to use conditional formatting but Im not exactly sure how
 
Jan 18, 2001
14,465
1
0
=($A$1="NO")

select "formula is" under Condition 1 and use the above formula, set the text format to what ever wnat.

you can copy formating settings by copy/paste special/formatting
 

Juice Box

Diamond Member
Nov 7, 2003
9,615
1
0
Originally posted by: HomeBrewerDude
=($A$1="NO")

select "formula is" under Condition 1 and use the above formula, set the text format to what ever wnat.

you can copy formating settings by copy/paste special/formatting

oh lol, Duh! Totally forgot about that. Thanks! ;)