LinkBack URL
About LinkBacks
hi ,
i want to color the cell with some condition...
1] if cell contains 1 no color if zero some color,
2] if number lye between 45 to 60 no color if less then 45 some color..
hi ,
i want to color the cell with some condition...
1] if cell contains 1 no color if zero some color,
2] if number lye between 45 to 60 no color if less then 45 some color..
Hello
In CF rules use these
Formula:
Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
How can you use Conditional Formating.
--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks