Hoping you good people can help me (again!)
I want to apply some conditional formatting to my excel sheet:
-If level states ">75" - colour cells only containing hours Green
-If level states "<20" - colour cells only containing hours Red
Blank cells to not be any colour
Can anyone help?
Check this out!
*Need to have numbers in the cells to be able to use the formatting.
*If you wish you click on *,a way to say ThankYou
Select Cell D3 and follow following steps:
Conditional Formatting>>New Rule>>Formula:
For Green: =AND($C3=">75",D3>0) Select format color green
For Red: =AND($C3="<20",D3>0) Select format color Red
Click on Format Painter. Select Entire range D3:G7.
Done.
Shashank Mishra
Please hit "Add Reputation" Button if you liked the answer.
1st formula would be
Formula:
Please Login or Register to view this content.
2nd would be
Formula:Please Login or Register to view this content.
Please Login or Register to view this content.Please Login or Register to view this content.
amazing - Thanks for the replies guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks