Forum Discussion
Conditional Formatting
Kevin,
Do the following steps
- Select cell A1.
- Go to Home >> Conditional Formatting >> New Rule.
- From the New Formatting Rule dialog box select the rule type of (Use a formula to determine which cells to format).
- In the formula box type this formula for example:
=SUM(H1, K1)>=70
- Finally, click Format button to determine the format that you want, then hit OK.
You can do the same thing for as many cells as you want.
Kevin,
Do the following steps
- Select cell A1.
- Go to Home >> Conditional Formatting >> New Rule.
- From the New Formatting Rule dialog box select the rule type of (Use a formula to determine which cells to format).
- In the formula box type this formula for example:
=SUM(H1, K1)>=70
- Finally, click Format button to determine the format that you want, then hit OK.
You can do the same thing for as many cells as you want.
Hi,
Apologies I have no idea how to create a new post here and have been going round in circles trying to search how to do it on this site.
I need some help with conditional formatting I'm trying to do.
I want to highlight a set of cells based on another set of cells vales.
I want to conditional format it so if the date in column A is past the date in column J highlight that cell in A red, and if its prior to the date in column J highlight green.
The issue I have is the dates in all the rows of columns A and J are different, is there a way to do this?
Hi Hayley,
However, better to start new one. That is simple - go to the space, e.g. https://techcommunity.microsoft.com/t5/Charts-and-Visualizing-Data/bd-p/Chart_Visual
and press the button
