Question

How will you change the colour of data in the range A1 to D4. (please guys answer its urgent)​

Answer 1

Answer:

the conditional formatting if the date entered in cell C2 is more than 60 days from today by typing =AND(C2<>””, C2>TODAY()+60) in the Format values where this formula is true: field. 6. Click on Format… and select green for the background color.

Explanation:

pls mark me brainliest

Answer 2

Select the data of the cells for which you want to change the colour.

Go to to the HOME tab and in the FORMAT group you will see an A icon.

Click on that and select the colour you want.

THANKS.