Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format a cell
Select the range you are needing then
Goto your Format toolbar Menu Conditional Formatting In the first drop down select cell Value Is In the second drop down select Greater than In the third drop down type in 1 Thenclick Format PatternsSelect your color Then click ok twice This should do it "Shawn" wrote: I want a cell to be highlighted in one color and when I enter some text, such as a number, I want it to change to a different color. How do I do something like that. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
Excel Auto-Format cell to email format | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) |