Color cells based on several other cells text

adam1993

New Member
Joined
May 16, 2018
Messages
16
I need some help with the following question...

If column "I" is blank and cell "F" says either "ABC, BCD, JOF, etc..." (several options) then I'd like to color cells "F" and "G" one color but if cell "F" is blank and cell "F" says either "GFA or OWN" then I'd like to color cell "F" & "G" a different color...


PLEASE HELP

FGHI
ARC/OwnRFI responded
ARCapprovedYESGW
GC/Sub/Coneed to fix...

<tbody>
</tbody>

In this case, I'd like the first row to color F & G color blue if it says one of 2 options and for the third row, I'd like the row to color red if it says one of many options...
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
"...but if cell "F" is blank and cell "F" says either "GFA or OWN" ..."

If cell F is blank how can it also be GFA or OWN ?
 
Last edited:
Upvote 0
Basically, if "I" is blank, I want column "f" to color 1 of 2 colors depending on the text in that cell. And if I add text into "I" to make it not blank, then the color in "F" goes away.

I think that adds some clarity.
 
Upvote 0

Forum statistics

Threads
1,203,462
Messages
6,055,563
Members
444,799
Latest member
CraigCrowhurst

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top