View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dax Arroway Dax Arroway is offline
external usenet poster
 
Posts: 70
Default CF to Color-Fill Row B:G w/Specific Text in One of the Cells

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
--
I would give my left hand to be ambidextrous!