Hi, in column B I have the numbers 1 to 40, I want to conditional format column B based on the Values of column C being less than 4 but keeping the numbers 1 to 40 in column B.
Thanks.
Hi, in column B I have the numbers 1 to 40, I want to conditional format column B based on the Values of column C being less than 4 but keeping the numbers 1 to 40 in column B.
Thanks.
Assuming that your data start in b2(headers in row1), then highlight your range in column b and in CF rules use this formula.
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.
Hello
try this
=AND($C1<4,$B1>0)
using CF
Regards
Jaya
Thank you Fotis1991 & jayajaya_4 for your reply, I have used jayajaya_4 suggestion and it works great, thank you both.
Regards,
Warston.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks