CF to Color-Fill Row B:G w/Specific Text in One of the Cells

  • Thread starter Thread starter Dax Arroway
  • Start date Start date
D

Dax Arroway

Hi All,
I'm in Excel 07 and I have a worksheet which is populated from another
worksheet, INDEX-formulas in all cells. Range is B2:G25. Column C gets
populated with either M or F. I'm looking for a CF method so that if there's
specifically an exact M in row C (not just an M in any word) that the whole
row turns a color.

The Fs need to do it too but change a different color and I'm guessing I'd
just use the same formula but have it look for Fs and change the Fill color,
right?

Can someone please help me out with a formula for that? Please.
Thanks in advance!
--Dax
 
Same question as yesterday only with a different range.

Thanks for the help. It actually gets worse. In column C I'm entering M or
F (for male or female) and I need to color the entire row either blue or pink
(yeah, I know, I know, sorry to stereotype but it's not my worksheet)
depending upon their sex. How do I specify the text in that specific column?
I tried =ISTEXT($C1,"M") but it says those are too many arguements. Not
sure where to go from there.
Any help?
Click to expand...

Did you not see the response you got yesterday that is exactly the same as
what Biff just posted?


Gord Dibben MS Excel MVP
 
Back
Top