Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for different cell contents
The worksheet has two rows which have numbers and some cells contain "N/A".
If the number in the top row is highest both top and bottom number need to be highlighted in yellow. If the top number is lowest or contains "N/A" the background needs to remain white. The conditional formatting works great until the cell with the "N/A". Excel views this as higher the any number. Does anyone have any suggestion for this. Thank you in adavance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for different cell contents
Try this ..
Select rows 1 & 2, and apply cond format Cond1's formula: =A$1="N/A" ("No format set") Cond2's formula: =A$1A$2 (set fill color: yellow) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "sweetsue516" wrote in message ... The worksheet has two rows which have numbers and some cells contain "N/A". If the number in the top row is highest both top and bottom number need to be highlighted in yellow. If the top number is lowest or contains "N/A" the background needs to remain white. The conditional formatting works great until the cell with the "N/A". Excel views this as higher the any number. Does anyone have any suggestion for this. Thank you in adavance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell contents in formula bar | Excel Discussion (Misc queries) | |||
using cell contents in a formula | Excel Worksheet Functions | |||
Using cell contents within a formula | Excel Worksheet Functions | |||
Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
Cell contents vs. Formula contents | Excel Discussion (Misc queries) |