Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If #, then Highlight
I'm needing to highlight the cells over a certain # in a column.
Hinky part is: these #s will change as the data changes. Column H = Items Sold I'm needing the worksheet to highlight the cells in that column 500. The Items Sold change daily. Just now sure how to go about this. Appreciate any help. Thank you! -TexJen |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If #, then Highlight
Conditional Formatting will do this for you
Assuming data in col E Select col E (E1 active) Click Format Conditional Formatting Formula Is: =AND(ISNUMBER(E1),E1500) Click "Format" button Patterns tab Green fill? OK out The extra check in the formula: ISNUMBER(E1) is to ensure that only real numbers will be monitored for CF trigger (otherwise any text in col E would also spuriously trigger the CF) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "TexJen" wrote: I'm needing to highlight the cells over a certain # in a column. Hinky part is: these #s will change as the data changes. Column H = Items Sold I'm needing the worksheet to highlight the cells in that column 500. The Items Sold change daily. Just now sure how to go about this. Appreciate any help. Thank you! -TexJen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight every other row | Excel Discussion (Misc queries) | |||
highlight row | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
how do i highlight every odd row | Excel Discussion (Misc queries) | |||
highlight every other row | Excel Discussion (Misc queries) |