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!

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

"lightbulb" wrote:

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!

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.

"lightbulb" wrote:

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!

Formatconditional FormattingFormula is

=COUNT(G16:J16)0

and select the color...

If this post helps click Yes
---------------
Jacob Skaria


"lightbulb" wrote:

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!