Hi Guru,
May I know is there any shortcut to create conditional formatting rules for google sheet?
I have following formula and create cell by cell. Wanted to know if there short cut to create this formula in a column?
For example :-
Row 27 --> J27>D27
Row 28 --> J28>D28
And so on and so forth
Untitled.jpg
Thank you in advance.
Last edited by cyee; 02-18-2021 at 11:14 AM. Reason: wrong subject
Note: Google Sheets is NOT Excel.
I have moved this to the appropriate section.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you Ali for correct me.
I amended the subject too
Use a formula to include your range, such as;
Please Login or Register to view this content.
Try the following:
Apply to range- J:J
Format cell if- Greater than
Next box- =D:D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks