Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I get cells to automaticly change colour on data input?
I am wanting cells to change colour to red if 'no' inputted and green if
'yes'. The no/yes are set up on validation drop down boxes. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I get cells to automaticly change colour on data input?
Conditional Formatting
Condition 1 Formula Is: =$A1="yes" format cell as Green Condition2 Formula Is: =$A1="no" format cell as Red "walltur" wrote: I am wanting cells to change colour to red if 'no' inputted and green if 'yes'. The no/yes are set up on validation drop down boxes. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I get cells to automaticly change colour on data input?
Hi Waltur,
Select the cells that you want to change colour. Then select FormatConditional Formatting. Cell Value IsEqual to Type Yes in the empty box and click the format button, choose your format. Click Add button and set your second condition. Hope this helps, Gav. "walltur" wrote: I am wanting cells to change colour to red if 'no' inputted and green if 'yes'. The no/yes are set up on validation drop down boxes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to automaticly change colour of font if y becomes < X | Excel Worksheet Functions | |||
Sum total cells to change colour | Excel Discussion (Misc queries) | |||
change highlight colour of selected cells | Excel Discussion (Misc queries) | |||
How do i make a range of cells change colour | Excel Worksheet Functions | |||
How can I change the colour of cells using an IF function? | Excel Worksheet Functions |