Replicate Conditional Formatting Results Into adjacent Cell

[Russ At Index]

Hi Everyone , hope you are all staying safe.

Don't really know if this is possible , but here goes ..
In cell B2 I have applied a conditional format rule , i would like , if it is possible to replicate the resulting colour of that
formatting into cell A2 , and continue it across my worksheet .... colour in D2 , replicate that colour in C2 etc etc .

Any ideas ? the data will be around 250 rows by a similar number of columns by the time I have finished,

Thanks ,

Russ.

 

[Joe4]

Is there a way to count the total number of each colour within the worksheet ?

If all the coloring is being done by conditional formatting, then simply use the same conditions in COUNTIF or COUNTIFS formula to count the number of cells meeting each condition.

This shows you how to do the more complex one (value between two numbers):

Count cells between two numbers

To count the number of cells that contain values between two numbers, you can use the COUNTIFS function. In the generic form of the formula (above), range represents a range of cells that contain numbers, A1 represents the lower boundary, and B1 represents the upper boundary of the numbers you...

exceljet.net