Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change a cell's color based on return value of a formula
A B C In this example on the left, I have set the "C"
column to be a 1 5 0 5 formula (=a1+b1), with this formula used in all rows. My font 2 5 -1 4 color for the entire spreadsheet is black. I want the value in the "C" column to change to "RED" if the value in "C1" (after the formula is applied) is less than "A1". If the value in"C1" is equal to "A1", change the color to "BLUE". I went in and used the conditional formatting option. For cell "C1" I had the conditional format reading: Condition 1 (cell "C1") "Cell Value is equal to A1" with the color set to "BLUE" (These conditions have been applied to the whole "C" column) When I get the "C1" value equal to "A1", no change occurs. Condition 1 (still cell "C1") "Cell Value is less than A1" with the color set to "RED" (These conditions have been applied to the whole "C" column) When I get the "C1" value equal to "A1", color changes to "RED" What I don't understand is the value in "C1" is equal to "A1", but the color is only changing if the conditional format is set to "less than". I guess I need help understanding what the program is doing. Help would be appreciated. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return adjacent cell's value based on formula | Excel Discussion (Misc queries) | |||
Formula to populate data in a cell based on another cell's color | Excel Discussion (Misc queries) | |||
CHANGE ONE CELL'S VALUE AND GET THE SAME RETURN - SOME HELP PLEASE | Excel Discussion (Misc queries) | |||
Have row color change to one of 8 different colors based on one cell's value (I, O, C, T, L, E, X, A) | Excel Discussion (Misc queries) | |||
Change value based on another cell's value | Excel Discussion (Misc queries) |