Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need solution to formula problem
Help please!
I have two rows of numbers with some cell that will contain 'N/A". If the top row is highest I need it highlighted yellow if it is not highest or is "N/A" the cell needs to remain with no fill. I can do a condtional formatting that works great until a cell contains the "N/A". Is there a formula that I can do in conditional formatting or some other options that will solve this problem. |
#2
|
|||
|
|||
As suggested in your multi-post in .programming
(please do not multi-post) 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 ... Help please! I have two rows of numbers with some cell that will contain 'N/A". If the top row is highest I need it highlighted yellow if it is not highest or is "N/A" the cell needs to remain with no fill. I can do a condtional formatting that works great until a cell contains the "N/A". Is there a formula that I can do in conditional formatting or some other options that will solve this problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula Problem | Excel Discussion (Misc queries) | |||
Problem with formula in Excel | Excel Worksheet Functions | |||
Vlookup, What is correct formula for problem below? | Excel Worksheet Functions | |||
Problem with Frequency() formula | Excel Worksheet Functions | |||
formula problem | Excel Discussion (Misc queries) |