Override Conditional Formatting

**Tillymint** · 05-14-2015, 11:08 AM

I am trying to add some conditional formatting to the spreadsheet in the picture attached.
I would like for the ROW to be filled in different colours based upon the combination of blank active cells within said row.

If as in my picture F2,G2,H2&I2 are NotBlank then I would like for the row to be filled Blue
If F2,G2&H2 are not Blank, but I2 is then I would like for the row to be filled Green
If F2&G2 are NotBlank, but H2 & I2 are then I would like the row to be Yellow
If F2 is NotBlank but G,H&I2 are then I would like the row to be Orange
If F2:I2 are all blank then I would like for the the row to stay white.

Is this possible?EXCEL TEST.png

**etaf** · 05-14-2015, 11:47 AM

you should be able to use a formula like

AND( $F2<>"",$G2 <> "", $H2 <> "", $I2 = "")
in conditional formatting and assign a colour

And add rules for each colour

if you attach a spreadsheet rather than an image that would help

Override Conditional Formatting

LinkBack

Thread Tools

Rate This Thread

Display

Override Conditional Formatting

Re: Override Conditional Formatting

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] I need to override a color fill set by Conditional Formatting

Override conditional formatting issue

Override conditional formatting

How can you override cell shading using Conditional formatting?

Prevent conditional formatting from being override

Bookmarks

Bookmarks

Posting Permissions