I have already used the conditional formatting option for another purpose. I
need to use either a function or code for these cells.

Any ideas?

"Duke Carey" wrote:

Select the first cell you want treated this way
Go to Format-Conditional Formatting
Select "Formula is"
enter =$f1="red" (change the 1 to whatever row you have selected)
click n the Format button
Go to the Patterns tab
Pick your color
OK your way back to the spreadsheet
Copy the current cell
Select all the cells you want to format this way
Use Edit-Paste Special-Formats to copy just the formatting

"CB" wrote:

I have a spreadsheet that I need to fill the interior color of the row red if
column f contains the text red. I need the data in each row to turn red if f
is red for columns a through e and g through m.
Is there an easy way to do this other than sorting/filtering. Is there some
way to do this with VBA?

Any help is appreciated.