Forum

Notifications
Clear all

conditional formatting

2 Posts
2 Users
0 Reactions
103 Views
(@brancc1234gmail-com)
Posts: 2
Active Member
Topic starter
 

I want to compare the values  in column a with values in adjacent cells and format those cells if greater than or less than value in column A

3.84 3.96 4.09 3.67 3.91 4.15
3.69 3.90 3.88 3.67 3.72 4.45
3.87 4.10 4.03 4.00 4.03 4.40
67.73 75.98 73.71 68.11 77.67 85.00
3.63 3.91 3.94 3.89 3.76 4.15
4.35 4.39 4.56 4.35 4.21 4.45
4.36 4.48 4.68 4.30 4.28 4.65
36.27 41.67 45.45 42.86 26.47 60.00
 
Posted : 21/10/2022 12:36 pm
Riny van Eekelen
(@riny)
Posts: 1246
Member Moderator
 

Hi Chuck,

The attached file contains an example with two conditional formatting rules to mark numbers greater (green) or less (red) than the one in column A.

Green: =B1>$A1

Red: =B1<$A1

both applied to $B$1:$F$8

Riny

 
Posted : 22/10/2022 12:28 am
Share: