| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i set more than three conditions in condition formatting?
I need to set up color coding for five different conditions - can you help me?
if A1 cell value is greater than or equal to 6 then color yellow if A1 cell value is between 5 and 6 then color silver if A1 cell value is between 4 and 5 then color blue if A1 cell value is less than 4 then color red if A1 cell value has no value (entered) then color cyan can we do this with conditional formatting or do we need VB for this? if vb is needed can i get some idea how to create the code... i am not good at coding...please help me.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Condition formatting & Formulas | Excel Worksheet Functions | |||
| VLOOKUP / Condition Formatting Help | Excel Discussion (Misc queries) | |||
| IF condition is true, shade cell (more than 3 conditions) | Excel Discussion (Misc queries) | |||
| Custom Formatting: Can I set up a condition? | Excel Worksheet Functions | |||
| IF Function with formatting condition | Excel Worksheet Functions | |||
Threaded Mode
