Hi all
I am trying to apply a conditional format to cell based on the conditional format of an adjacent cell:
basically if for example cell B1 (percentage) has a conditional format set to change to red if below a certain number, how can I automatically change cell A1 to change to red too?
I have attached a file for ease of explaining.
Cheers
Select the range of cells A1:A2
Conditional Formatting
Use the "Use a formula..." option and use this formula:
=B1>0.2
Apply the desired formats
OK out
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Apologies, but on excel2010 where is the 2use a formula option" ? sorry if its a dumb question
Goto the Home tab>Conditional Formatting>Manage rules
Select New Rule>Use a formula to determine which cells to format
Enter the formula in the box below where it says:
Format values where this formula is true.
thank you - sorted found and solved
Good deal. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks