Hello All,
This is probably incredibly simple but for some reason I can't get it to work!
I'm trying to do a simple conditional format, for example-
In cell B1 I want to highlight the cell is it's less that A1 and vice versa. I know there's an option in conditional format to do this but it's highlighting everything rather than anything less.
Any ideas...?
In B1
=b1<a1
In A1.
=a1<b1
Same color.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I thought that was how to do it!
Unfortunately I'm still having a problem. I've attached the sheet I am working from.
In cell m12 to m50 I want tio highlight cells that are less than values in cells f12 to f50. For some reason it doesn't want to do it properly.
I can't see what I'm doing wrong!
In F12 and copy down.
=RIGHT(E12,LEN(E12)-3)+0
Now CF should works correctly
I already have a formula in that cell, how do I enter your suggestion?
You must enter at the end of your formula +0.(the red part in my post#4
Ah, yes, thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks