Conditional Formatting

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

I want to color an entire row if certain conditions are
present:

If A2 is empty or does not equal named range "Industry
Type" then color entire row Red.

If B2 is empty or does not equal named range "ClientType"
then color entire row Red.

Conversely, if either cell has a value present then no
color is needed.

I am trying to use the "conditional format" option but I
am not sure how to "write it".

Any help is appreciated!
Thanks.
sandy
 
Hi Sandy,
This did it for me:
1) select the range of cells to format
2) in the Conditional Format dialog specify Formula Is and use
=OR($A2<>"Industry",$B2<>"Client")

I do not see why you mentioned "empty". If a cell is empty then it follows
its value does not equal "Industry Type" (or anything else for that matter)

Best wishes
Bernard
 
I want to color an entire row if certain conditions are
present:

If A2 is empty or does not equal named range "Industry
Type" then color entire row Red.

If B2 is empty or does not equal named range "ClientType"
then color entire row Red.

Conversely, if either cell has a value present then no
color is needed.

I am trying to use the "conditional format" option but I
am not sure how to "write it".

Any help is appreciated!
Thanks.
sandy
Click to expand...

Hi Sandy,

I'm not sure if this is what you're looking for, but here is what I have:

Select your row

Condition 1
=OR($A2="",$A2<>IndustryType), and choose your formatting

Click on Add

Condition 2
=OR($B2="",$B2<>ClientType), and choose your formatting

Hope this helps!
 
Thank you so much.
-----Original Message-----
Hi Sandy,
This did it for me:
1) select the range of cells to format
2) in the Conditional Format dialog specify Formula Is and use
=OR($A2<>"Industry",$B2<>"Client")

I do not see why you mentioned "empty". If a cell is empty then it follows
its value does not equal "Industry Type" (or anything else for that matter)

Best wishes
Bernard




.
Click to expand...
 
Thanks but the cells I'm referencing contain Validation
Data (A2 is validated with a dropdown box
of "IndustryType" to choose from. If the cell hasn't been
populated with a selection and is blank I want it Red, IF
the cell has a selection showing, I don't want it colored.
This is to help the end user identify which cells need a
selection.

Does that explain it?

I'm not very good with the description I'm afraid.

thanks.

sandy
 
Sandy said:
I want to color an entire row if certain conditions are
present:

If A2 is empty or does not equal named range "Industry
Type" then color entire row Red.

If B2 is empty or does not equal named range "ClientType"
then color entire row Red.

Conversely, if either cell has a value present then no
color is needed.

I am trying to use the "conditional format" option but I
am not sure how to "write it".

Any help is appreciated!
Thanks.
sandy
Click to expand...


After selected entire range:
in formulas:
=OR(OR(ISBLANK(A2),A2<>IndustryType),OR(ISBLANK(B2),B2<>ClientType))
..i
 
Back
Top