When you change number in one cell, certain cells change colour. How to?
I have a table in which the first line is a phase number and it goes from 1 to 4. I would like to have something, that when I change this number a certain range in that row would change colour.
My logic is, if A1="1" then colour in range A1 to A10 is green.
if A1="2" then colour in range A1 to A10 is yellow.
And so on .
How to do it?
ok, I see how it's done in older version. I use 2007 and I can't do it. (don't know how to)
I have this data as a table (CTRL T) and I want to have 4 variables for each row. For 1 = red, 2=blue, 3=green 4=yellow
Is it possible to have that multiple criteria?
I attached a file for easzer understanding.
Last edited by brazool; 11-27-2008 at 09:36 AM.
I'll move your thread to the 2007 forum.
Might help you faster
I think the 2007 CF dialog is a masterpiece of obfuscation and and a classic example of an inappropriate user interface, but it is not too hard to work out how to apply simple CF like this from the 2003 instructions.
Thank you Bob, but can you please post a procedure or something. I want to be able to do that myself.
Thank you for your time!!
Tab Home> Group Styles> Conditional Formatting> Clear Rules (just in case)
Tab Home> Group Styles> Conditional Formatting> Manage Rules
Click New Rule
Select the bottom option, >Use a formule to determine which cells to format
Enter =$B5-2 in the formula box
Click Format...>Fill and select a colour
OK twice, then Click New Rule again and repeat the process for the other values and fill colours.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1