Jump to content

how to do certain things in Excel (newbie question)

Go to solution Solved by Needfuldoer,

Conditional formatting will let you dynamically set the color of the cell (both background and text) depending on its value.

 

https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f

I have downloaded an Excel attendance summary template, where if you key in V inside a single cell, it will change color according to the fx function on top.

I do not know how to set it up so that my excel worksheet can do the same. 

 

Could someone tell me how to achieve this?? 

 

Here is the template I was talking about .

 

 

月考勤表微软官网.xltx

If it is not broken, let's fix till it is. 

Link to comment
Share on other sites

Link to post
Share on other sites

On 9/30/2022 at 5:48 PM, Needfuldoer said:

Conditional formatting will let you dynamically set the color of the cell (both background and text) depending on its value.

 

https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f

I see. Thanks for the help!! ALready bookmarked that article! 

If it is not broken, let's fix till it is. 

Link to comment
Share on other sites

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share


×