Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Colour
Can't seem to get any help with this :(
I have two two columns in excel a b Jan 200 Feb 456 Mar 544 June 1201 'b' numbers already has a conditional format in place using the when "cell value is" function. So when cell value is less than 1200 the numbers go red. when its above 1200 they go green... What I want next is for the dates in column 'a' to change the same colour as the 'b' numbers. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Colour
use Formula Is
in place of Value Is for cell A1 formula is: =B11200 and pick green, etc. -- Gary's Student "Dave" wrote: Can't seem to get any help with this :( I have two two columns in excel a b Jan 200 Feb 456 Mar 544 June 1201 'b' numbers already has a conditional format in place using the when "cell value is" function. So when cell value is less than 1200 the numbers go red. when its above 1200 they go green... What I want next is for the dates in column 'a' to change the same colour as the 'b' numbers. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Colour
In , Dave
spake thusly: Can't seem to get any help with this :( See my follow-up to your identical other posting. -dman- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change cell colour by simply clicking on it | Excel Discussion (Misc queries) | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Fill colour a cell from the linked cell | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Function to return colour of formatted cell | Excel Worksheet Functions |