Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format
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
|
|||
|
|||
Conditional Format
Select your range, say A1:B999 and with the activecell in Row 1, use this as the
conditional formatting formula (not value is): =$b1<1200 give it a nice format and =$b11200 and give it a nice format What happens at exactly 1200? 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to copy a conditional format formula as paste value | Excel Discussion (Misc queries) | |||
Conditional Format | Excel Discussion (Misc queries) | |||
Conditional Formating. Remove condition, keep format? | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions |