Conditional formatting Based on cell A text with conditions in Cell B

R

Raicomm

I am running a large pivot chart and each topic can have 5 sub
categories. Each of the 5 categories has a different threshold that I
want to conditionally format.

So row A has Bob, Row B has Break, Lunch, meeting; Row C has time 15,
30, 60 minutes. I need to set the condition for Break as over 15 is
red, lunch over 30 is red and meeting is over 60 is red.

I have read around a bit and haven't found a solution was wondering if
it had been encountered before.


Thanks,

M
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
Cobditional Formatting Rows based on dates in action plan. 0
How to filter rows data based on background color of individual cells 3
Excel 2010 Conditional Formatting 2
Excel 2003 - Adding up cells that contain Conditional Formatting 10
Conditional Formatting Across Multiple Cells 0
conditional formatting based on a different cell 2
Conditional formatting 3

Top