Dear All,
Good Day,i need help on conditional formatting rule, i am using excel 2013 and i am maintaining log i want to run some rules but i couldn't kindly help me.
once i enter (character C) other row number should be strike through with color kindly help.
Example:- E5(0) Q5(C)
Last edited by sms1432; 05-21-2017 at 07:43 AM.
try
Select E5
CF: =AND(Q5="C",ISNUMBER(E5)
set color
Hi sms1432,
In CF choose "New Rule" then choose "Use a Formula"
Then use this formula =$Q2="C" and apply it to your Range of cells / Table.
Regards
peterrc
A slight mod to Sandy's formula...
Conditional Formatting
- Highlight applicable range >> E5:Q200
- Home Tab >> Styles >> Conditional Formatting >> New Rule
- Select a Rule Type: Use a formula to determine which cells to format
- Edit the Rule Description: Format values where this formula is true: =AND($Q5="C",ISNUMBER($E5))
- Format… [Number, Font, Border, Fill]
- OK >> OK
You could even adjust your range to what it might be such as, A2:Y400
If you are wanting just E5 and Q5 to be highlighted, and not other cells, then you need to apply conditional formatting specifically to each cell.
Last edited by jeffreybrown; 05-21-2017 at 09:25 AM.
HTH
Regards, Jeff
Dear Peterrc
Thank you so much i got it and i apply on my complete sheet.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks