Conditional formatting
Closed
osi
-
Dec 22, 2015 at 09:34 AM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Dec 22, 2015 at 01:08 PM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Dec 22, 2015 at 01:08 PM
Related:
- Conditional formatting
- Excel conditional formatting based on date - Guide
- How to clear formatting in excel - Guide
- Formatting windows 7 - Guide
- Hp formatting tool - Download - Storage
- Formatting sd card to fat32 - Guide
1 response
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
149
Dec 22, 2015 at 01:08 PM
Dec 22, 2015 at 01:08 PM
Hi osi,
Hope this works for you :
- Select the cells you want to highlight when the cell you are testing is negative.
- on the "Home" tab of the ribbon select the "Conditional Formatting" button and choose "New Rule"
- at the top of the box select "Use a formula to determine which cells to format"
- at the middle of the box (Format values where the formula is true) type the following (replacing my Test Cell which I am using cell B2 with the cell you are testing)
- at the bottom of the box click on the [Format]button.
- in the new box that opens click the "Fill" tab
- choose the colour you want to be the highlight colour. In the other tabs you can change font and font colour and ....
- Click the [OK] button. The box closes.
- Click the [OK] button again. The box closes.
- Click the [OK] button once more. The box closes.
DONE :^)
Please let me know how you get on.
I really appreciate thank you messages as a payment for solving issues :o)
Hope this works for you :
- Select the cells you want to highlight when the cell you are testing is negative.
- on the "Home" tab of the ribbon select the "Conditional Formatting" button and choose "New Rule"
- at the top of the box select "Use a formula to determine which cells to format"
- at the middle of the box (Format values where the formula is true) type the following (replacing my Test Cell which I am using cell B2 with the cell you are testing)
=$B2<0
- at the bottom of the box click on the [Format]button.
- in the new box that opens click the "Fill" tab
- choose the colour you want to be the highlight colour. In the other tabs you can change font and font colour and ....
- Click the [OK] button. The box closes.
- Click the [OK] button again. The box closes.
- Click the [OK] button once more. The box closes.
DONE :^)
Please let me know how you get on.
I really appreciate thank you messages as a payment for solving issues :o)
