Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to come up with a visual warning in my Excel tracking
inventories, the condition and requirement as an example is: Cell column F is the current inventories Cell column J is the run rate of sales Cell column E is where I want to use color instead of text to track logical condition are If column F < (column J * 0.6) then E column will be color yellow If column F column J then E column will be color Red Else column E is white Cna anyone helps? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I restore cell gridlines lost after coloring a cell? | Excel Discussion (Misc queries) | |||
Cell Coloring | Excel Discussion (Misc queries) | |||
Cell coloring | Excel Discussion (Misc queries) | |||
Cell Coloring | Excel Worksheet Functions | |||
conditional cell coloring | Excel Discussion (Misc queries) |