Conditional Formatting

L

lightbulb

Is there a way to set conditional formatting by referencing another cell?

For Example I'm setting the formatting for cell E16, and I want it to be
green if cells G16-J16 have a value in them.

Thanks!
 
E

Eduardo

Hi,
Go to cell E16 then do Conditional formating, where the formula is enter

=$G$16:$J$16<>""

if this helps please click yes, thanks
 
S

Sean Timmons

in your conditional formatting, use Formula is in the first drop-down box.
then, you can type =COUNTA(G16:J16)=4 and set your formats.

Put $'s as necessary to lock down your columns or rows, and paste special,
formats across or down if desired.
 
J

Jacob Skaria

Format>conditional Formatting>Formula is

=COUNT(G16:J16)>0

and select the color...

If this post helps click Yes
 
Top