conditional formating affecting fill color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how can i use conditional formatting to affect the fill color in another cell?
 
When creating the condition select the "Formula" option, not "Cell Value".

Then you can put in any formula you like in the text box.

I use R1C1 mode so I would have something like: "=RC6>7". Then regardless of
the cell that I'm on it will look at column 6 of the row I'm on to see if it
is greater than 7.

Easy.

James R-S.
 
More detail please.

The CF must be entered in the cell you want colored, but you can use the value
of another cell to CF color a cell.

i.e. you can have A1 colored based upon the value in B1

Select A1 then Format>CF>Formula is: =B1="hoohah"

Gord Dibben Excel MVP

On Tue, 9 Nov 2004 23:44:03 -0800, "Ahmad Hakim" <Ahmad
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
Excel VBA 1
inserting a hyperlink into a conditionally formatted cell, Excel 2 2
Question about conditional formatting of zeros in Excel 0
Formatting cell 2
make all cells in same row match cell formatted with fill color 2
Conditional formatting, based on a different cell? 3
Conditional Formatting 1

Back
Top